package com.ys.mapper.product;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface ProductMapper {

    /**
     * 删除采购合同单详情表信息
     */
    public int deleteTcgPurchaseContractItemByPbid(@Param("pbid")String pbid);

    /**
     * 删除采购预入库详情表信息
     */
     int deleteTcgPurchasePreStorageSonByPbid(@Param("pbid")String pbid);

    /**
     * 删除发票预核销单详情表信息
     */
    int deleteTcgInvoiceOffsetItemByPbid(@Param("pbid")String pbid);

    /**
     * 删除采购付款详情表信息
     */
    int deleteTcgPurchasePaymentItemByPbid(@Param("pbid")String pbid);


    /**
     * 删除采购计划母件表
     */
    int deleteTcgPurchaseByPlanGoodsByPbid(@Param("pbid")String pbid);


    /**
     * 删除采购计划子件表
     */
    int deleteTcgPurchaseByPlanSonByPbid(@Param("pbid")String pbid);



    /**
     * 删除采购订单子表
     */
    int deleteTcgPurchaseByOrderSonByPid(@Param("pid")Long pid);

    /**
     * 获取单月订单的序号
     */
    Integer getPurchaseByOrderMonthNoByMonth(@Param("month")String month);



}